<?php include '../../authorization_check.php' ?>
<?php include '../../checkPCVPCSecretary.php'; ?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-9">
<title>View Defined Courses</title>
<SCRIPT TYPE="text/javascript" src= "../../commonutils/util/util.js"> </SCRIPT>

</head>
<style type="text/css">
/* th {text-align: right} */
</style>
<body>

<?php include 'top.html' ?>

<?php include 'notifier.php' ?>

<p>
<table border=1 cellpadding=3>
<tr>
<th>COURSE CODE </th>
<th>COURSE NAME </th>
<th>CREDIT </th>
<th>DESCRIPTION </th>
</tr>
<?php
require_once '../../commonutils/db/DBConnectionManager.php';

	$sqlquery = " select courseCode, courseName, credit, description from course where programCode = ". $programCode ;
	 
	/* // echo $sqlquery."<br>";  */

	$result = DBConnectionManager::query($sqlquery);
	while($row = mysql_fetch_assoc($result)){
		echo "<tr>";
		echo "<td>".$row['courseCode']." &nbsp;</td>";
		echo "<td>".$row['courseName']." &nbsp;</td>";
		echo "<td>".$row['credit']."     &nbsp;</td>";
		echo "<td>".$row['description']."&nbsp;</td>";
		echo "</tr>";		
	}

?>

</table>
</p>  

<p><a href=DefineNewCourse.php>Define a new course</a></p>
<p><a href=DeleteCourse.php>Delete a predefined course</a></p>

<?php include 'bottom.php' ?>

</body>


</html>